﻿CREATE TABLE [dbo].[ClaimLineItems]
(
[AssignedNumber] [nvarchar] (6) NULL,
[ServiceLineRevenueCode] [nvarchar] (48) NULL,
[LineItemChargeAmount] [money] NULL,
[UnitOrBasisForMeasurementCode] [nvarchar] (2) NULL,
[ServiceUnitCount] [int] NULL,
[ServiceLineRate] [nchar] (10) NULL,
[ServiceDate] [nvarchar] (50) NULL,
[SubscriberPrimaryIdentifier] [nvarchar] (80) NULL,
[PatientAccountNumber] [nvarchar] (38) NULL,
[TransactionSetControlNumber] [nvarchar] (9) NULL,
[SubscriberHierarchicalIDNumber] [nvarchar] (9) NULL,
[InterchangeControlNumber] [nvarchar] (9) NULL,
[GroupControlNumber] [nvarchar] (9) NULL,
[ClaimIDKey] [int] NULL,
[ClaimLineItemIDKey] [int] NOT NULL IDENTITY(1, 1),
[ProductOrServiceIDQualifier] [nvarchar] (2) NULL,
[ProcedureCode] [nvarchar] (50) NULL,
[ProcedureModifier1] [nvarchar] (2) NULL,
[ProcedureModifier2] [nvarchar] (2) NULL,
[ProcedureModifier3] [nvarchar] (2) NULL,
[ProcedureModifier4] [nvarchar] (2) NULL,
[LineItemDeniedChargeOrNonCoveredChargeAmount] [money] NULL,
[BTSMessageID] [nvarchar] (100) NULL,
[BTSInterchangeID] [nvarchar] (100) NULL
) ON [PRIMARY]


